package com.trkj.dao.jpa;

import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojos.SickroomtypeTable;
import com.trkj.vo.SickroomTypeVo;

public interface ISickroomtypeTableDao extends CrudRepository<SickroomtypeTable, Long> {
	
	@Query("select new com.trkj.vo.SickroomTypeVo(S.typeid,S.charge,S.typename) "
			+ " from SickroomtypeTable S")
	public List<SickroomTypeVo> findallSickroomType();

}
